﻿using System;

namespace edowork.com.Model
{
    #region inventory_logInfo

    [Serializable]
    public class inventory_logInfo
    {
        #region Private fields

        protected string _warehouseid = String.Empty;
        protected string _areaid = String.Empty;
        protected string _storageid = String.Empty;
        protected string _productcode = String.Empty;
        protected decimal _qty;
        protected DateTime _sysdate;

        #endregion

        public inventory_logInfo() { }

        #region Public Properties

        public string Warehouseid
        {
            get { return _warehouseid; }
            set { _warehouseid = value; }
        }

        public string Areaid
        {
            get { return _areaid; }
            set { _areaid = value; }
        }

        public string Storageid
        {
            get { return _storageid; }
            set { _storageid = value; }
        }

        public string Productcode
        {
            get { return _productcode; }
            set { _productcode = value; }
        }

        public decimal Qty
        {
            get { return _qty; }
            set { _qty = value; }
        }

        public DateTime Sysdate
        {
            get { return _sysdate; }
            set { _sysdate = value; }
        }

        #endregion

        #region Public SQL Script

        public string SQL_Insert()
        {
            return "insert into inventory_log(Warehouseid,Areaid,Storageid,Productcode,Qty,Sysdate) values('{0}','{1}','{2}','{3}',{4},{5})";
        }

        #endregion

    }

    #endregion
}

